<!DOCTYPE HTML>
<!-- NewPage -->
<html lang="en"><head>
    <title>SQL </title>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <meta name="dc.created" content="2020-03-25">
    <link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">
    <link rel="stylesheet" type="text/css" href="../../../../dokka-javadoc-stylesheet.css" title="Style">
    <link rel="stylesheet" type="text/css" href="../../../../jquery/jquery-ui.css" title="Style">
    <script type="text/javascript" src="../../../../jquery/jquery-3.3.1.js"></script>
    <script type="text/javascript" src="../../../../jquery/jquery-migrate-3.0.1.js"></script>
    <script type="text/javascript" src="../../../../jquery/jquery-ui.js"></script>

    <script type="text/javascript" src="../../../../search.js"></script>
    <script async type="text/javascript" src="../../../../module-search-index.js"></script>
    <script async type="text/javascript" src="../../../../package-search-index.js"></script>
    <script async type="text/javascript" src="../../../../type-search-index.js"></script>
    <script async type="text/javascript" src="../../../../member-search-index.js"></script>
    <script async type="text/javascript" src="../../../../tag-search-index.js"></script>
</head><body>
<script type="text/javascript">
var pathtoroot = "../../../../";
</script>
<noscript>
    <div>JavaScript is disabled on your browser.</div>
</noscript><header role="banner">
    <nav role="navigation">
        <div class="fixedNav">
            <!-- ========= START OF TOP NAVBAR ======= -->
            <div class="topNav"><a id="navbar.top">
                <!--   -->
            </a>
                <div class="skipNav"><a href="#skip.navbar.top" title="Skip navigation links">Skip navigation links</a>
                </div>
                <a id="navbar.top.firstrow">
                    <!--   -->
                </a>
                <ul class="navList" title="Navigation">
    <li><a href="../../../../index.html">Overview</a></li>
    
    <li><a href="package-summary.html">Package</a></li>
    
    <li class="navBarCell1Rev">Class</li>
    
    <li><a href="package-tree.html">Tree</a></li>
    
    <li><a href="../../../../deprecated.html">Deprecated</a></li>
    <li><a href="../../../../index-files/index-1.html">Index</a></li>
    <li>Help</li>
</ul></div>
            <div class="subNav">
<ul class="navList" id="allclasses_navbar_top" style="display: block;">
    <li><a href="../../../../allclasses.html">All&nbsp;Classes</a></li>
</ul>

<ul class="navListSearch">
<li><label for="search">SEARCH:</label>
<input type="text" id="search" value="search" class="ui-autocomplete-input" autocomplete="off" placeholder="Search">
<input type="reset" id="reset" value="reset">
</li>
</ul>
<div>
<script type="text/javascript"><!--
  allClassesLink = document.getElementById("allclasses_navbar_top");
  if(window==top) {
    allClassesLink.style.display = "block";
  }
  else {
    allClassesLink.style.display = "none";
  }
  //-->
</script>
<noscript>
<div>JavaScript is disabled on your browser.</div>
</noscript>
</div>
<a id="skip.navbar.top">
<!--   -->
</a></div><!-- ========= END OF TOP NAVBAR ========= -->
        </div>
        <div class="navPadding">&nbsp;</div>
        <script type="text/javascript"><!--
        $('.navPadding').css('padding-top', $('.fixedNav').css("height"));
        //-->
        </script>
    </nav>
</header>

<main role="main">
    <div class="header">
        <div class="subTitle"><span class="packageLabelInType">Package</span>&nbsp;<a href="package-summary.html"></a></div>
        <h2 title="Class SQL" class="title">Class SQL</h2>
    </div>
    <div class="contentContainer">
        <!-- <ul class="inheritance">
            <li>java.lang.Object</li>
            <li>
                <ul class="inheritance">
                    <li>adaptation.Adaptation</li>
                </ul>
            </li>
        </ul> TODO inheritance tree -->
        <div class="description">
            <ul class="blockList">
                <li class="blockList">
                    
                    <hr>
                    <pre class="wrap-overflow">

public abstract class <span class="typeNameLabel"><a href=SQL.html>SQL</a></span>

                    </pre>
                    <div class="block"><p>说明: 数据库操作</p><p>创建者: tum0r</p><p>时间: 2021/8/19 11:58</p></div>
                </li>
            </ul>
        </div>
        <div class="summary">
            <ul class="blockList">
                <li class="blockList">
                <!-- ======== NESTED CLASS SUMMARY ======== -->
                    
                    <!-- =========== FIELD SUMMARY =========== -->
                    
                    <section role="region">
                        <ul class="blockList">
                            <li class="blockList"><a id="field.summary">
                                <!--   -->
                            </a>
                                <h3>Field Summary</h3>
                                <div class="memberSummary">
                                    <table>
                                        <caption><span>Fields</span><span class="tabEnd">&nbsp;</span></caption>
                                        <tr>
                                            <th class="colFirst" scope="col">Modifier and Type</th>
                                            <th class="colSecond" scope="col">Field</th>
                                            <th class="colLast" scope="col">Description</th>
                                        </tr>
                                        
                                        <tr class="altColor">
                                            <td class="colFirst"><code>private  <a href=https://docs.oracle.com/javase/8/docs/api/java/sql/Connection.html>Connection</a></code></td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#connection>connection</a></code></th>
                                            <td class="colLast"></td>
                                        </tr>
                                        
                                        <tr class="rowColor">
                                            <td class="colFirst"><code>private  <a href=https://docs.oracle.com/javase/8/docs/api/java/sql/PreparedStatement.html>PreparedStatement</a></code></td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#statement>statement</a></code></th>
                                            <td class="colLast"></td>
                                        </tr>
                                        
                                        <tr class="altColor">
                                            <td class="colFirst"><code>private final <a href=../../models/database/DatabaseConnect.html>DatabaseConnect</a></code></td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#info>info</a></code></th>
                                            <td class="colLast"></td>
                                        </tr>
                                        
                                    </table>
                                </div>
                            </li>
                        </ul>
                    </section>
                    
                    <!-- ======== CONSTRUCTOR SUMMARY ======== -->
                    
                    <section role="region">
                        <ul class="blockList">
                            <li class="blockList"><a id="constructor.summary">
                                <!--   -->
                            </a>
                                <h3>Constructor Summary</h3>
                                <div class="memberSummary">
                                    <table>
                                        <caption><span>Constructors</span><span class="tabEnd">&nbsp;</span></caption>
                                        <tbody>
                                        <tr>
                                            <th class="colFirst" scope="col">Constructor</th>
                                            <th class="colLast" scope="col">Description</th>
                                        </tr>

                                        
                                            <tr class="altColor">
                                                <th class="colConstructorName" scope="row"><code><span class="memberNameLink"><a
                                                        href="#SQL(DatabaseConnect)">SQL</a></span>(<a href=../../models/database/DatabaseConnect.html>DatabaseConnect</a> info)</code></th>
                                                <td class="colLast"></td>
                                            </tr>
                                        

                                        </tbody>
                                    </table>
                                </div>
                            </li>
                        </ul>
                    </section>
                    
                    <!-- =========== ENUM CONSTANT SUMMARY =========== -->
                    
                    <!-- ========== METHOD SUMMARY =========== -->
                    
                    <section role="region">
                        <ul class="blockList">
                            <li class="blockList"><a id="method.summary">
                                <!--   -->
                            </a>
                                <h3>Method Summary</h3>
                                <div class="memberSummary">
                                    <div role="tablist" aria-orientation="horizontal">
                                        <button role="tab" aria-selected="true" aria-controls="memberSummary_tabpanel" tabindex="0" onkeydown="switchTab(event)" id="t0" class="activeTableTab">All Methods</button>
                                        <!-- TODO: Instance and Concrete Methods #1118 -->
                                    </div>
                                    <div id="memberSummary_tabpanel" role="tabpanel">
                                    <table aria-labelledby="t0">
                                        <tr>
                                            <th class="colFirst" scope="col">Modifier and Type</th>
                                            <th class="colSecond" scope="col">Method</th>
                                            <th class="colLast" scope="col">Description</th>
                                        </tr>
                                        
                                        <tr id="i0" class="altColor">
                                            <td class="colFirst"><code>final <a href=https://docs.oracle.com/javase/8/docs/api/java/sql/Connection.html>Connection</a></code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#getConnection()>getConnection</a>() </code>
                                            </th>
                                            <td class="colLast">数据库连接，子类里实例化和使用</td>
                                        </tr>
                                        
                                        <tr id="i1" class="rowColor">
                                            <td class="colFirst"><code>final <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-unit/index.html>Unit</a></code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#setConnection(Connection)>setConnection</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/sql/Connection.html>Connection</a> connection) </code>
                                            </th>
                                            <td class="colLast">数据库连接，子类里实例化和使用</td>
                                        </tr>
                                        
                                        <tr id="i2" class="altColor">
                                            <td class="colFirst"><code>final <a href=https://docs.oracle.com/javase/8/docs/api/java/sql/PreparedStatement.html>PreparedStatement</a></code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#getStatement()>getStatement</a>() </code>
                                            </th>
                                            <td class="colLast">执行SQL语句，子类里实例化和使用</td>
                                        </tr>
                                        
                                        <tr id="i3" class="rowColor">
                                            <td class="colFirst"><code>final <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-unit/index.html>Unit</a></code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#setStatement(PreparedStatement)>setStatement</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/sql/PreparedStatement.html>PreparedStatement</a> statement) </code>
                                            </th>
                                            <td class="colLast">执行SQL语句，子类里实例化和使用</td>
                                        </tr>
                                        
                                        <tr id="i4" class="altColor">
                                            <td class="colFirst"><code>final <a href=../../models/database/DatabaseConnect.html>DatabaseConnect</a></code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#getInfo()>getInfo</a>() </code>
                                            </th>
                                            <td class="colLast"></td>
                                        </tr>
                                        
                                        <tr id="i5" class="rowColor">
                                            <td class="colFirst"><code>abstract <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Boolean.html>Boolean</a></code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#open(String,Integer,String,String,String,String)>open</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> host, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html>Integer</a> port, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> databaseName, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> username, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> password, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> parameters) </code>
                                            </th>
                                            <td class="colLast">启动数据库连接，子类实现</td>
                                        </tr>
                                        
                                        <tr id="i6" class="altColor">
                                            <td class="colFirst"><code>final <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Boolean.html>Boolean</a></code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#open()>open</a>() </code>
                                            </th>
                                            <td class="colLast">启动数据库连接</td>
                                        </tr>
                                        
                                        <tr id="i7" class="rowColor">
                                            <td class="colFirst"><code>final <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Boolean.html>Boolean</a></code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#isOpen()>isOpen</a>() </code>
                                            </th>
                                            <td class="colLast">数据库连接是否启动</td>
                                        </tr>
                                        
                                        <tr id="i8" class="altColor">
                                            <td class="colFirst"><code>final <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Boolean.html>Boolean</a></code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#close()>close</a>() </code>
                                            </th>
                                            <td class="colLast">关闭数据库连接</td>
                                        </tr>
                                        
                                        <tr id="i9" class="rowColor">
                                            <td class="colFirst"><code>abstract <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-unit/index.html>Unit</a></code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#initDatabase(String)>initDatabase</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> databaseName) </code>
                                            </th>
                                            <td class="colLast">初始化数据库</td>
                                        </tr>
                                        
                                        <tr id="i10" class="altColor">
                                            <td class="colFirst"><code>final <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-unit/index.html>Unit</a></code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#initDatabase()>initDatabase</a>() </code>
                                            </th>
                                            <td class="colLast">初始化数据库</td>
                                        </tr>
                                        
                                        <tr id="i11" class="rowColor">
                                            <td class="colFirst"><code>final <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Boolean.html>Boolean</a></code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#setParameters(String,Object)>setParameters</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters) </code>
                                            </th>
                                            <td class="colLast">设置SQL语句参数</td>
                                        </tr>
                                        
                                        <tr id="i12" class="altColor">
                                            <td class="colFirst"><code>final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; &lt;ERROR CLASS&gt;&lt;<a href=SQL.html#selectObjects(String,Object)>T</a>&gt;</code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#selectObjects(String,Object)>selectObjects</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters) </code>
                                            </th>
                                            <td class="colLast">查询数据库，并以对象集合的形式返回数据</td>
                                        </tr>
                                        
                                        <tr id="i13" class="rowColor">
                                            <td class="colFirst"><code>final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; &lt;ERROR CLASS&gt;&lt;<a href=SQL.html#selectObjects(Class,String,Object)>T</a>&gt;</code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#selectObjects(Class,String,Object)>selectObjects</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html>Class</a>&lt;<a href=SQL.html#selectObjects(Class,String,Object)>T</a>&gt; targetClass, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters) </code>
                                            </th>
                                            <td class="colLast">Java中调用，查询数据库，并以对象集合的形式返回数据</td>
                                        </tr>
                                        
                                        <tr id="i14" class="altColor">
                                            <td class="colFirst"><code>final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; <a href=SQL.html#selectObject(String,Object)>T</a></code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#selectObject(String,Object)>selectObject</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters) </code>
                                            </th>
                                            <td class="colLast">查询数据库，并以对象的形式返回数据</td>
                                        </tr>
                                        
                                        <tr id="i15" class="rowColor">
                                            <td class="colFirst"><code>final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; <a href=SQL.html#selectObject(Class,String,Object)>T</a></code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#selectObject(Class,String,Object)>selectObject</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html>Class</a>&lt;<a href=SQL.html#selectObject(Class,String,Object)>T</a>&gt; targetClass, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters) </code>
                                            </th>
                                            <td class="colLast">Java中调用，查询数据库，并以对象的形式返回数据</td>
                                        </tr>
                                        
                                        <tr id="i16" class="altColor">
                                            <td class="colFirst"><code>final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; &lt;ERROR CLASS&gt;&lt;<a href=SQL.html#selectObjectsUnsafe(String)>T</a>&gt;</code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#selectObjectsUnsafe(String)>selectObjectsUnsafe</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command) </code>
                                            </th>
                                            <td class="colLast">不安全的查询数据库，并以对象集合的形式返回数据</td>
                                        </tr>
                                        
                                        <tr id="i17" class="rowColor">
                                            <td class="colFirst"><code>final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; &lt;ERROR CLASS&gt;&lt;<a href=SQL.html#selectObjectsUnsafe(Class,String)>T</a>&gt;</code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#selectObjectsUnsafe(Class,String)>selectObjectsUnsafe</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html>Class</a>&lt;<a href=SQL.html#selectObjectsUnsafe(Class,String)>T</a>&gt; targetClass, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command) </code>
                                            </th>
                                            <td class="colLast">不安全的查询数据库，并以对象集合的形式返回数据</td>
                                        </tr>
                                        
                                        <tr id="i18" class="altColor">
                                            <td class="colFirst"><code>final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; <a href=SQL.html#selectObjectUnsafe(String)>T</a></code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#selectObjectUnsafe(String)>selectObjectUnsafe</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command) </code>
                                            </th>
                                            <td class="colLast">不安全的查询数据库，并以对象的形式返回数据</td>
                                        </tr>
                                        
                                        <tr id="i19" class="rowColor">
                                            <td class="colFirst"><code>final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; <a href=SQL.html#selectObjectUnsafe(Class,String)>T</a></code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#selectObjectUnsafe(Class,String)>selectObjectUnsafe</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html>Class</a>&lt;<a href=SQL.html#selectObjectUnsafe(Class,String)>T</a>&gt; targetClass, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command) </code>
                                            </th>
                                            <td class="colLast">不安全的查询数据库，并以对象的形式返回数据</td>
                                        </tr>
                                        
                                        <tr id="i20" class="altColor">
                                            <td class="colFirst"><code>final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; &lt;ERROR CLASS&gt;&lt;<a href=SQL.html#selectValues(String,Object)>T</a>&gt;</code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#selectValues(String,Object)>selectValues</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters) </code>
                                            </th>
                                            <td class="colLast">查询数据库，并以值集合的形式返回数据</td>
                                        </tr>
                                        
                                        <tr id="i21" class="rowColor">
                                            <td class="colFirst"><code>final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; &lt;ERROR CLASS&gt;&lt;<a href=SQL.html#selectValues(Class,String,Object)>T</a>&gt;</code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#selectValues(Class,String,Object)>selectValues</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html>Class</a>&lt;<a href=SQL.html#selectValues(Class,String,Object)>T</a>&gt; targetClass, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters) </code>
                                            </th>
                                            <td class="colLast">Java中调用，查询数据库，并以值集合的形式返回数据</td>
                                        </tr>
                                        
                                        <tr id="i22" class="altColor">
                                            <td class="colFirst"><code>final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; <a href=SQL.html#selectValue(String,Object)>T</a></code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#selectValue(String,Object)>selectValue</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters) </code>
                                            </th>
                                            <td class="colLast">查询数据库，并以值的形式返回数据</td>
                                        </tr>
                                        
                                        <tr id="i23" class="rowColor">
                                            <td class="colFirst"><code>final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; <a href=SQL.html#selectValue(Class,String,Object)>T</a></code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#selectValue(Class,String,Object)>selectValue</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html>Class</a>&lt;<a href=SQL.html#selectValue(Class,String,Object)>T</a>&gt; targetClass, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters) </code>
                                            </th>
                                            <td class="colLast">Java中调用，查询数据库，并以值的形式返回数据</td>
                                        </tr>
                                        
                                        <tr id="i24" class="altColor">
                                            <td class="colFirst"><code>final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; &lt;ERROR CLASS&gt;&lt;<a href=SQL.html#selectValuesUnsafe(Class,String)>T</a>&gt;</code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#selectValuesUnsafe(Class,String)>selectValuesUnsafe</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html>Class</a>&lt;<a href=SQL.html#selectValuesUnsafe(Class,String)>T</a>&gt; targetClass, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command) </code>
                                            </th>
                                            <td class="colLast">Java中调用，不安全查询数据库，并以值的形式返回数据</td>
                                        </tr>
                                        
                                        <tr id="i25" class="rowColor">
                                            <td class="colFirst"><code>final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; <a href=SQL.html#selectValueUnsafe(Class,String)>T</a></code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#selectValueUnsafe(Class,String)>selectValueUnsafe</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html>Class</a>&lt;<a href=SQL.html#selectValueUnsafe(Class,String)>T</a>&gt; targetClass, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command) </code>
                                            </th>
                                            <td class="colLast">Java中调用，不安全查询数据库，并以值的形式返回数据</td>
                                        </tr>
                                        
                                        <tr id="i26" class="altColor">
                                            <td class="colFirst"><code>final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; <a href=../../models/database/PageModel.html>PageModel</a>&lt;<a href=SQL.html#selectPageBase(Class,Integer,Integer,String,String,Object)>T</a>&gt;</code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#selectPageBase(Class,Integer,Integer,String,String,Object)>selectPageBase</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html>Class</a>&lt;<a href=SQL.html#selectPageBase(Class,Integer,Integer,String,String,Object)>T</a>&gt; targetClass, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html>Integer</a> index, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html>Integer</a> pageSize, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> pageCommand, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters) </code>
                                            </th>
                                            <td class="colLast">分页查询基类，不能直接调用，在具体实现类里调用</td>
                                        </tr>
                                        
                                        <tr id="i27" class="rowColor">
                                            <td class="colFirst"><code>final <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html>Integer</a></code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#update(String,Object)>update</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters) </code>
                                            </th>
                                            <td class="colLast">执行更新数据库操作，包括增、改和删</td>
                                        </tr>
                                        
                                        <tr id="i28" class="altColor">
                                            <td class="colFirst"><code>final <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html>Integer</a></code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#updateUnsafe(String)>updateUnsafe</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command) </code>
                                            </th>
                                            <td class="colLast">不安全的执行更新数据库操作，包括增、改和删</td>
                                        </tr>
                                        
                                        <tr id="i29" class="rowColor">
                                            <td class="colFirst"><code>&lt;ERROR CLASS&gt;&lt;<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a>&gt;</code>
                                            </td>
                                            <th class="colSecond" scope="row"><code><a href=SQL.html#getGeneratedKeys()>getGeneratedKeys</a>() </code>
                                            </th>
                                            <td class="colLast">获取生成的键</td>
                                        </tr>
                                        
                                        </tbody>
                                    </table>
                                </div>
                                <ul class="blockList">
                                
                                    <li class="blockList"><a id="methods.inherited.from.class.java.lang.Object">
                                        <!--   -->
                                    </a>
                                        <h3>Methods inherited from class&nbsp;java.lang.Object</h3>
                                        <code>clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString,
                                            wait, wait, wait</code></li>
                                </ul>
                            </li>
                        </ul>
                    </section>
                    
                </li>
            </ul>
        </div>
        <div class="details">
            <ul class="blockList">
                <li class="blockList">
                    <!-- ========= CONSTRUCTOR DETAIL ======== -->
                    
                    <section role="region">
                        <ul class="blockList">
                            <li class="blockList"><a id="constructor.detail">
                                <!--   -->
                            </a>
                                <h3>Constructor Detail</h3>
                                
                                <a name="SQL(DatabaseConnect)"></a>
                                <ul class="blockList">
                                    <li class="blockList">
                                        <h4>SQL</h4>
                                        <pre>SQL(<a href=../../models/database/DatabaseConnect.html>DatabaseConnect</a> info)</pre>
                                        <div class="block"></div>
                                        
                                        <dl>
                                            <dt><span class="paramLabel">Parameters:</span></dt>
                                            
                                            
                                            <dd><code>info</code> - 数据库连接信息</dd>
                                            
                                            
                                        </dl>
                                        
                                    </li>
                                </ul>
                                
                            </li>
                        </ul>
                    </section>
                    
                    <!-- ============ METHOD DETAIL ========== -->
                    
                    <section role="region">
                        <ul class="blockList">
                            <li class="blockList"><a id="method.detail">
                                <!--   -->
                            </a>
                                <h3>Method Detail</h3>
                                
                                <a id="getConnection()">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>getConnection</h4>
                                        <pre class="methodSignature"> final <a href=https://docs.oracle.com/javase/8/docs/api/java/sql/Connection.html>Connection</a> <a href=SQL.html#getConnection()>getConnection</a>()</pre>
                                        <div class="block"><p>数据库连接，子类里实例化和使用</p></div>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="setConnection(Connection)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>setConnection</h4>
                                        <pre class="methodSignature"> final <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-unit/index.html>Unit</a> <a href=SQL.html#setConnection(Connection)>setConnection</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/sql/Connection.html>Connection</a> connection)</pre>
                                        <div class="block"><p>数据库连接，子类里实例化和使用</p></div>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="getStatement()">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>getStatement</h4>
                                        <pre class="methodSignature"> final <a href=https://docs.oracle.com/javase/8/docs/api/java/sql/PreparedStatement.html>PreparedStatement</a> <a href=SQL.html#getStatement()>getStatement</a>()</pre>
                                        <div class="block"><p>执行SQL语句，子类里实例化和使用</p></div>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="setStatement(PreparedStatement)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>setStatement</h4>
                                        <pre class="methodSignature"> final <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-unit/index.html>Unit</a> <a href=SQL.html#setStatement(PreparedStatement)>setStatement</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/sql/PreparedStatement.html>PreparedStatement</a> statement)</pre>
                                        <div class="block"><p>执行SQL语句，子类里实例化和使用</p></div>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="getInfo()">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>getInfo</h4>
                                        <pre class="methodSignature"> final <a href=../../models/database/DatabaseConnect.html>DatabaseConnect</a> <a href=SQL.html#getInfo()>getInfo</a>()</pre>
                                        <div class="block"></div>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="open(String,Integer,String,String,String,String)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>open</h4>
                                        <pre class="methodSignature"> abstract <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Boolean.html>Boolean</a> <a href=SQL.html#open(String,Integer,String,String,String,String)>open</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> host, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html>Integer</a> port, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> databaseName, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> username, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> password, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> parameters)</pre>
                                        <div class="block"><p>启动数据库连接，子类实现</p></div>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="open()">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>open</h4>
                                        <pre class="methodSignature"> final <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Boolean.html>Boolean</a> <a href=SQL.html#open()>open</a>()</pre>
                                        <div class="block"><p>启动数据库连接</p></div>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="isOpen()">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>isOpen</h4>
                                        <pre class="methodSignature"> final <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Boolean.html>Boolean</a> <a href=SQL.html#isOpen()>isOpen</a>()</pre>
                                        <div class="block"><p>数据库连接是否启动</p></div>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="close()">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>close</h4>
                                        <pre class="methodSignature"> final <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Boolean.html>Boolean</a> <a href=SQL.html#close()>close</a>()</pre>
                                        <div class="block"><p>关闭数据库连接</p></div>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="initDatabase(String)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>initDatabase</h4>
                                        <pre class="methodSignature"> abstract <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-unit/index.html>Unit</a> <a href=SQL.html#initDatabase(String)>initDatabase</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> databaseName)</pre>
                                        <div class="block"><p>初始化数据库</p></div>
                                        
                                        <dl>
                                            <dt><span class="paramLabel">Parameters:</span></dt>
                                            
                                            
                                            <dd><code>databaseName</code> - 数据库名</dd>
                                            
                                            
                                        </dl>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="initDatabase()">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>initDatabase</h4>
                                        <pre class="methodSignature"> final <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-unit/index.html>Unit</a> <a href=SQL.html#initDatabase()>initDatabase</a>()</pre>
                                        <div class="block"><p>初始化数据库</p></div>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="setParameters(String,Object)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>setParameters</h4>
                                        <pre class="methodSignature"> final <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Boolean.html>Boolean</a> <a href=SQL.html#setParameters(String,Object)>setParameters</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters)</pre>
                                        <div class="block"><p>设置SQL语句参数</p></div>
                                        
                                        <dl>
                                            <dt><span class="paramLabel">Parameters:</span></dt>
                                            
                                            
                                            <dd><code>command</code> - SQL语句，语句中参数占位符为 @p 或 @P 然后加数字，例如 @p0, @P1</dd>
                                            
                                            
                                            
                                            <dd><code>parameters</code> - 要替换占位符的参数</dd>
                                            
                                            
                                        </dl>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="selectObjects(String,Object)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>selectObjects</h4>
                                        <pre class="methodSignature"> final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; &lt;ERROR CLASS&gt;&lt;<a href=SQL.html#selectObjects(String,Object)>T</a>&gt; <a href=SQL.html#selectObjects(String,Object)>selectObjects</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters)</pre>
                                        <div class="block"><p>查询数据库，并以对象集合的形式返回数据</p></div>
                                        
                                        <dl>
                                            <dt><span class="paramLabel">Parameters:</span></dt>
                                            
                                            
                                            <dd><code>command</code> - SQL语句，语句中参数占位符为 @p 或 @P 然后加数字，例如 @p0, @P1</dd>
                                            
                                            
                                            
                                            <dd><code>parameters</code> - 要替换占位符的参数</dd>
                                            
                                            
                                        </dl>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="selectObjects(Class,String,Object)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>selectObjects</h4>
                                        <pre class="methodSignature"> final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; &lt;ERROR CLASS&gt;&lt;<a href=SQL.html#selectObjects(Class,String,Object)>T</a>&gt; <a href=SQL.html#selectObjects(Class,String,Object)>selectObjects</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html>Class</a>&lt;<a href=SQL.html#selectObjects(Class,String,Object)>T</a>&gt; targetClass, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters)</pre>
                                        <div class="block"><p>Java中调用，查询数据库，并以对象集合的形式返回数据</p></div>
                                        
                                        <dl>
                                            <dt><span class="paramLabel">Parameters:</span></dt>
                                            
                                            
                                            <dd><code>targetClass</code> - 转换的Java类</dd>
                                            
                                            
                                            
                                            <dd><code>command</code> - SQL语句，语句中参数占位符为 @p 或 @P 然后加数字，例如 @p0, @P1</dd>
                                            
                                            
                                            
                                            <dd><code>parameters</code> - 要替换占位符的参数</dd>
                                            
                                            
                                        </dl>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="selectObject(String,Object)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>selectObject</h4>
                                        <pre class="methodSignature"> final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; <a href=SQL.html#selectObject(String,Object)>T</a> <a href=SQL.html#selectObject(String,Object)>selectObject</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters)</pre>
                                        <div class="block"><p>查询数据库，并以对象的形式返回数据</p></div>
                                        
                                        <dl>
                                            <dt><span class="paramLabel">Parameters:</span></dt>
                                            
                                            
                                            <dd><code>command</code> - SQL语句，语句中参数占位符为 @p 或 @P 然后加数字，例如 @p0, @P1</dd>
                                            
                                            
                                            
                                            <dd><code>parameters</code> - 要替换占位符的参数</dd>
                                            
                                            
                                        </dl>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="selectObject(Class,String,Object)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>selectObject</h4>
                                        <pre class="methodSignature"> final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; <a href=SQL.html#selectObject(Class,String,Object)>T</a> <a href=SQL.html#selectObject(Class,String,Object)>selectObject</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html>Class</a>&lt;<a href=SQL.html#selectObject(Class,String,Object)>T</a>&gt; targetClass, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters)</pre>
                                        <div class="block"><p>Java中调用，查询数据库，并以对象的形式返回数据</p></div>
                                        
                                        <dl>
                                            <dt><span class="paramLabel">Parameters:</span></dt>
                                            
                                            
                                            
                                            
                                            <dd><code>command</code> - SQL语句，语句中参数占位符为 @p 或 @P 然后加数字，例如 @p0, @P1</dd>
                                            
                                            
                                            
                                            <dd><code>parameters</code> - 要替换占位符的参数</dd>
                                            
                                            
                                        </dl>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="selectObjectsUnsafe(String)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>selectObjectsUnsafe</h4>
                                        <pre class="methodSignature">@<a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-deprecated/index.html>Deprecated</a>(message = 此方法不安全，会引起SQL注入攻击, replaceWith = @<a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-replace-with/index.html>ReplaceWith</a>(imports = {}, expression = selectObjects(command: String, vararg parameters: Any?))) final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; &lt;ERROR CLASS&gt;&lt;<a href=SQL.html#selectObjectsUnsafe(String)>T</a>&gt; <a href=SQL.html#selectObjectsUnsafe(String)>selectObjectsUnsafe</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command)</pre>
                                        <div class="block"><p>不安全的查询数据库，并以对象集合的形式返回数据</p></div>
                                        
                                        <dl>
                                            <dt><span class="paramLabel">Parameters:</span></dt>
                                            
                                            
                                            <dd><code>command</code> - SQL语句</dd>
                                            
                                            
                                        </dl>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="selectObjectsUnsafe(Class,String)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>selectObjectsUnsafe</h4>
                                        <pre class="methodSignature">@<a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-deprecated/index.html>Deprecated</a>(message = 此方法不安全，会引起SQL注入攻击, replaceWith = @<a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-replace-with/index.html>ReplaceWith</a>(imports = {}, expression = selectObjects(targetClass: Class&lt;T&gt;, command: String, vararg parameters: Any?))) final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; &lt;ERROR CLASS&gt;&lt;<a href=SQL.html#selectObjectsUnsafe(Class,String)>T</a>&gt; <a href=SQL.html#selectObjectsUnsafe(Class,String)>selectObjectsUnsafe</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html>Class</a>&lt;<a href=SQL.html#selectObjectsUnsafe(Class,String)>T</a>&gt; targetClass, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command)</pre>
                                        <div class="block"><p>不安全的查询数据库，并以对象集合的形式返回数据</p></div>
                                        
                                        <dl>
                                            <dt><span class="paramLabel">Parameters:</span></dt>
                                            
                                            
                                            
                                            
                                            <dd><code>command</code> - SQL语句</dd>
                                            
                                            
                                        </dl>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="selectObjectUnsafe(String)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>selectObjectUnsafe</h4>
                                        <pre class="methodSignature">@<a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-deprecated/index.html>Deprecated</a>(message = 此方法不安全，会引起SQL注入攻击, replaceWith = @<a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-replace-with/index.html>ReplaceWith</a>(imports = {}, expression = selectObject(command: String, vararg parameters: Any?))) final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; <a href=SQL.html#selectObjectUnsafe(String)>T</a> <a href=SQL.html#selectObjectUnsafe(String)>selectObjectUnsafe</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command)</pre>
                                        <div class="block"><p>不安全的查询数据库，并以对象的形式返回数据</p></div>
                                        
                                        <dl>
                                            <dt><span class="paramLabel">Parameters:</span></dt>
                                            
                                            
                                            <dd><code>command</code> - SQL语句</dd>
                                            
                                            
                                        </dl>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="selectObjectUnsafe(Class,String)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>selectObjectUnsafe</h4>
                                        <pre class="methodSignature">@<a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-deprecated/index.html>Deprecated</a>(message = 此方法不安全，会引起SQL注入攻击, replaceWith = @<a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-replace-with/index.html>ReplaceWith</a>(imports = {}, expression = selectObject(targetClass: Class&lt;T&gt;, command: String, vararg parameters: Any?))) final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; <a href=SQL.html#selectObjectUnsafe(Class,String)>T</a> <a href=SQL.html#selectObjectUnsafe(Class,String)>selectObjectUnsafe</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html>Class</a>&lt;<a href=SQL.html#selectObjectUnsafe(Class,String)>T</a>&gt; targetClass, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command)</pre>
                                        <div class="block"><p>不安全的查询数据库，并以对象的形式返回数据</p></div>
                                        
                                        <dl>
                                            <dt><span class="paramLabel">Parameters:</span></dt>
                                            
                                            
                                            
                                            
                                            <dd><code>command</code> - SQL语句</dd>
                                            
                                            
                                        </dl>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="selectValues(String,Object)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>selectValues</h4>
                                        <pre class="methodSignature"> final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; &lt;ERROR CLASS&gt;&lt;<a href=SQL.html#selectValues(String,Object)>T</a>&gt; <a href=SQL.html#selectValues(String,Object)>selectValues</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters)</pre>
                                        <div class="block"><p>查询数据库，并以值集合的形式返回数据</p></div>
                                        
                                        <dl>
                                            <dt><span class="paramLabel">Parameters:</span></dt>
                                            
                                            
                                            <dd><code>command</code> - SQL语句，语句中参数占位符为 @p 或 @P 然后加数字，例如 @p0, @P1</dd>
                                            
                                            
                                            
                                            <dd><code>parameters</code> - 要替换占位符的参数</dd>
                                            
                                            
                                        </dl>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="selectValues(Class,String,Object)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>selectValues</h4>
                                        <pre class="methodSignature"> final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; &lt;ERROR CLASS&gt;&lt;<a href=SQL.html#selectValues(Class,String,Object)>T</a>&gt; <a href=SQL.html#selectValues(Class,String,Object)>selectValues</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html>Class</a>&lt;<a href=SQL.html#selectValues(Class,String,Object)>T</a>&gt; targetClass, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters)</pre>
                                        <div class="block"><p>Java中调用，查询数据库，并以值集合的形式返回数据</p></div>
                                        
                                        <dl>
                                            <dt><span class="paramLabel">Parameters:</span></dt>
                                            
                                            
                                            <dd><code>targetClass</code> - 转换的Java类</dd>
                                            
                                            
                                            
                                            <dd><code>command</code> - SQL语句，语句中参数占位符为 @p 或 @P 然后加数字，例如 @p0, @P1</dd>
                                            
                                            
                                            
                                            <dd><code>parameters</code> - 要替换占位符的参数</dd>
                                            
                                            
                                        </dl>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="selectValue(String,Object)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>selectValue</h4>
                                        <pre class="methodSignature"> final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; <a href=SQL.html#selectValue(String,Object)>T</a> <a href=SQL.html#selectValue(String,Object)>selectValue</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters)</pre>
                                        <div class="block"><p>查询数据库，并以值的形式返回数据</p></div>
                                        
                                        <dl>
                                            <dt><span class="paramLabel">Parameters:</span></dt>
                                            
                                            
                                            <dd><code>command</code> - SQL语句，语句中参数占位符为 @p 或 @P 然后加数字，例如 @p0, @P1</dd>
                                            
                                            
                                            
                                            <dd><code>parameters</code> - 要替换占位符的参数</dd>
                                            
                                            
                                        </dl>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="selectValue(Class,String,Object)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>selectValue</h4>
                                        <pre class="methodSignature"> final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; <a href=SQL.html#selectValue(Class,String,Object)>T</a> <a href=SQL.html#selectValue(Class,String,Object)>selectValue</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html>Class</a>&lt;<a href=SQL.html#selectValue(Class,String,Object)>T</a>&gt; targetClass, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters)</pre>
                                        <div class="block"><p>Java中调用，查询数据库，并以值的形式返回数据</p></div>
                                        
                                        <dl>
                                            <dt><span class="paramLabel">Parameters:</span></dt>
                                            
                                            
                                            
                                            
                                            <dd><code>command</code> - SQL语句，语句中参数占位符为 @p 或 @P 然后加数字，例如 @p0, @P1</dd>
                                            
                                            
                                            
                                            <dd><code>parameters</code> - 要替换占位符的参数</dd>
                                            
                                            
                                        </dl>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="selectValuesUnsafe(Class,String)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>selectValuesUnsafe</h4>
                                        <pre class="methodSignature">@<a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-deprecated/index.html>Deprecated</a>(message = 此方法不安全，会引起SQL注入攻击, replaceWith = @<a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-replace-with/index.html>ReplaceWith</a>(imports = {}, expression = selectValues(targetClass: Class&lt;T&gt;, command: String, vararg parameters: Any?))) final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; &lt;ERROR CLASS&gt;&lt;<a href=SQL.html#selectValuesUnsafe(Class,String)>T</a>&gt; <a href=SQL.html#selectValuesUnsafe(Class,String)>selectValuesUnsafe</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html>Class</a>&lt;<a href=SQL.html#selectValuesUnsafe(Class,String)>T</a>&gt; targetClass, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command)</pre>
                                        <div class="block"><p>Java中调用，不安全查询数据库，并以值的形式返回数据</p></div>
                                        
                                        <dl>
                                            <dt><span class="paramLabel">Parameters:</span></dt>
                                            
                                            
                                            
                                            
                                            <dd><code>command</code> - SQL语句，语句中参数占位符为 @p 或 @P 然后加数字，例如 @p0, @P1</dd>
                                            
                                            
                                        </dl>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="selectValueUnsafe(Class,String)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>selectValueUnsafe</h4>
                                        <pre class="methodSignature">@<a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-deprecated/index.html>Deprecated</a>(message = 此方法不安全，会引起SQL注入攻击, replaceWith = @<a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-replace-with/index.html>ReplaceWith</a>(imports = {}, expression = selectValue(targetClass: Class&lt;T&gt;, command: String, vararg parameters: Any?))) final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; <a href=SQL.html#selectValueUnsafe(Class,String)>T</a> <a href=SQL.html#selectValueUnsafe(Class,String)>selectValueUnsafe</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html>Class</a>&lt;<a href=SQL.html#selectValueUnsafe(Class,String)>T</a>&gt; targetClass, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command)</pre>
                                        <div class="block"><p>Java中调用，不安全查询数据库，并以值的形式返回数据</p></div>
                                        
                                        <dl>
                                            <dt><span class="paramLabel">Parameters:</span></dt>
                                            
                                            
                                            
                                            
                                            <dd><code>command</code> - SQL语句，语句中参数占位符为 @p 或 @P 然后加数字，例如 @p0, @P1</dd>
                                            
                                            
                                        </dl>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="selectPageBase(Class,Integer,Integer,String,String,Object)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>selectPageBase</h4>
                                        <pre class="methodSignature"> final &lt;T extends <a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-any/index.html>Any</a>&gt; <a href=../../models/database/PageModel.html>PageModel</a>&lt;<a href=SQL.html#selectPageBase(Class,Integer,Integer,String,String,Object)>T</a>&gt; <a href=SQL.html#selectPageBase(Class,Integer,Integer,String,String,Object)>selectPageBase</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Class.html>Class</a>&lt;<a href=SQL.html#selectPageBase(Class,Integer,Integer,String,String,Object)>T</a>&gt; targetClass, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html>Integer</a> index, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html>Integer</a> pageSize, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> pageCommand, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters)</pre>
                                        <div class="block"><p>分页查询基类，不能直接调用，在具体实现类里调用</p></div>
                                        
                                        <dl>
                                            <dt><span class="paramLabel">Parameters:</span></dt>
                                            
                                            
                                            <dd><code>targetClass</code> - 结果的强类型</dd>
                                            
                                            
                                            
                                            <dd><code>index</code> - 页号，从0开始</dd>
                                            
                                            
                                            
                                            <dd><code>pageSize</code> - 每页有多少数据</dd>
                                            
                                            
                                            
                                            <dd><code>command</code> - SQL语句，语句中参数占位符为 @p 或 @P 然后加数字，例如 @p0, @P1</dd>
                                            
                                            
                                            
                                            <dd><code>pageCommand</code> - 查询总数据量的SQL语句</dd>
                                            
                                            
                                            
                                            <dd><code>parameters</code> - 要替换占位符的参数</dd>
                                            
                                            
                                        </dl>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="update(String,Object)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>update</h4>
                                        <pre class="methodSignature"> final <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html>Integer</a> <a href=SQL.html#update(String,Object)>update</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command, <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a> parameters)</pre>
                                        <div class="block"><p>执行更新数据库操作，包括增、改和删</p></div>
                                        
                                        <dl>
                                            <dt><span class="paramLabel">Parameters:</span></dt>
                                            
                                            
                                            <dd><code>command</code> - SQL语句，语句中参数占位符为 @p 或 @P 然后加数字，例如 @p0, @P1</dd>
                                            
                                            
                                            
                                            <dd><code>parameters</code> - 要替换占位符的参数</dd>
                                            
                                            
                                        </dl>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="updateUnsafe(String)">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockList"
                                          >
                                    <li class="blockList">
                                        <h4>updateUnsafe</h4>
                                        <pre class="methodSignature">@<a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-deprecated/index.html>Deprecated</a>(message = 此方法不安全，会引起SQL注入攻击, replaceWith = @<a href=https://kotlinlang.org/api/latest/jvm/stdlib/kotlin/-replace-with/index.html>ReplaceWith</a>(imports = {}, expression = update(command: String, vararg parameters: Any?))) final <a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html>Integer</a> <a href=SQL.html#updateUnsafe(String)>updateUnsafe</a>(<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/String.html>String</a> command)</pre>
                                        <div class="block"><p>不安全的执行更新数据库操作，包括增、改和删</p></div>
                                        
                                        <dl>
                                            <dt><span class="paramLabel">Parameters:</span></dt>
                                            
                                            
                                            <dd><code>command</code> - SQL语句</dd>
                                            
                                            
                                        </dl>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                                <a id="getGeneratedKeys()">
                                    <!--   -->
                                </a>
                                <ul class=
                                              "blockListLast"
                                          >
                                    <li class="blockList">
                                        <h4>getGeneratedKeys</h4>
                                        <pre class="methodSignature"> &lt;ERROR CLASS&gt;&lt;<a href=https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html>Object</a>&gt; <a href=SQL.html#getGeneratedKeys()>getGeneratedKeys</a>()</pre>
                                        <div class="block"><p>获取生成的键</p></div>
                                        
                                        <!-- TODO missing return annotation -->
                                    </li>
                                </ul>
                                
                            </li>
                        </ul>
                    </section>
                    
                </li>
            </ul>
        </div>
    </div>
</main>
<footer role="contentinfo">
    <nav role="navigation">
        <!-- ======= START OF BOTTOM NAVBAR ====== -->
        <div class="bottomNav"><a id="navbar.bottom">
            <!--   -->
        </a>
            <div class="skipNav"><a href="#skip.navbar.bottom" title="Skip navigation links">Skip navigation links</a>
            </div>
            <a id="navbar.bottom.firstrow">
                <!--   -->
            </a>
            <ul class="navList" title="Navigation">
    <li><a href="../../../../index.html">Overview</a></li>
    
    <li><a href="package-summary.html">Package</a></li>
    
    <li class="navBarCell1Rev">Class</li>
    
    <li><a href="package-tree.html">Tree</a></li>
    
    <li><a href="../../../../deprecated.html">Deprecated</a></li>
    <li><a href="../../../../index-files/index-1.html">Index</a></li>
    <li>Help</li>
</ul></div>
        <a id="skip.navbar.bottom">
            <!--   -->
        </a>
        <div class="subNav">
<ul class="navList" id="allclasses_navbar_top" style="display: block;">
    <li><a href="../../../../allclasses.html">All&nbsp;Classes</a></li>
</ul>
<div>
<script type="text/javascript"><!--
  allClassesLink = document.getElementById("allclasses_navbar_top");
  if(window==top) {
    allClassesLink.style.display = "block";
  }
  else {
    allClassesLink.style.display = "none";
  }
  //-->
</script>
<noscript>
<div>JavaScript is disabled on your browser.</div>
</noscript>
</div>
<a id="skip.navbar.top">
<!--   -->
</a></div><!-- ======== END OF BOTTOM NAVBAR ======= -->
    </nav>
</footer><ul class="ui-autocomplete ui-front ui-menu ui-widget ui-widget-content" id="ui-id-1" tabindex="0"
    style="display: none;"></ul>
<span role="status" aria-live="assertive" aria-relevant="additions" class="ui-helper-hidden-accessible"></span>
</body>
</html>
